Variance (fld), Variance (fld, condFld), Variance (fld, condFld, cond), Variance (x)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to find the variance of a set of values in your report. For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Variance({file.AMOUNT})

Calculates the variance of all values in the Amount field.

Variance({file.RESULTS}, {file.DATE},"daily")

Calculates the variation for each group of laboratory test results in the Results field. The test results are separated into groups whenever the value in the Date field changes to a new day.

The following examples are applicable to Crystal syntax:

Variance({file.SCORES}, {file.TEACHERS}) % Variance({file.TEACHERS})

Groups values in the Scores field by teacher, and calculates the variance for each teacher group as a percentage of the variance of the values for the entire report (for all teachers listed).

Variance([{file.QTY1}, {file.QTY2}, {file.QTY3}, {file.QTY4}])

Returns 17.00 where Qty1 = 2, Qty2 = 2, Qty3 = 10, and Qty4 = 8.

Comments

Variance is calculated using the following technique:

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com